package com.xiaoxu.intranetweb.mybatisplusSzappdb.excelEntity;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.xiaoxu.intranetweb.mybatisplusSzappdb.vo.StatisticsVo;
import lombok.Builder;
import lombok.Data;

import java.math.BigDecimal;
import java.util.List;
@ContentRowHeight(23)
//@HeadRowHeight(20)
@ColumnWidth(25)
@Data
public class FinancialStatisticsExcelEn {
    //    厂名
    @ExcelIgnore
    private String plantFullName;

    //收货单位
    @ExcelProperty(value = "收货单位",index = 0)
    private String cpyName;
    //供货单位
    @ExcelProperty(value = "供货单位",index = 1)
    private String cpySupplyCoName;
    @ExcelProperty(value = "本期入账",index = 2)
    private BigDecimal thisPeriodAccount;
    //供货子单位
    //本期入账
    @ExcelIgnore
    private String thisPeriod;
    //是否入账
//    这个不需要
    @ExcelIgnore
    private String ifAccount;
    //本期实交款
    @ExcelProperty(value = "本期实交款",index = 3)
    private BigDecimal thisPeriodRecharge;
    //总欠款
    @ExcelProperty(value = "总欠款",index = 4)
    private BigDecimal totalDebt;
    //上期结余额
    @ExcelProperty(value = "上期结余额",index = 5)
    private BigDecimal lastPeriodBalance;
    //本期结余额
    @ExcelProperty(value = "本期结余额",index = 6)
    private BigDecimal thisPeriodBalance;
    //当前余额
    @ExcelProperty(value = "当前余额",index = 7)
    private BigDecimal balance;
    //品种
    @ExcelProperty(value = "品种",index = 8)
    private String pdtName;
    //单价
    @ExcelProperty(value = "单价",index = 9)
    private String price;
    //车数
    @ExcelProperty(value = "车数",index = 10)
    private Integer carNum;
    //本期发货量
    @ExcelProperty(value = "本期发货量",index = 11)
    private BigDecimal thisPeriodDelivery;
    //本期发货金额
    @ExcelProperty(value = "本期发货金额",index = 12)
    private BigDecimal thisPeriodDeliveryMoney;
    //    截至上期累计消费金额
    @ExcelIgnore
    private BigDecimal lastPeriodConsumption;
    @ExcelIgnore
    private BigDecimal thisPeriodConsumption;
    //    截至上期所有入账
    @ExcelIgnore
    private BigDecimal lastPeriodAccount;
    //    所有入账
    @ExcelIgnore
    private BigDecimal allAccount;
    //    截止本期所有入账

    //    截至本期的所有交款
    @ExcelIgnore
    private String thisPeriodPayment;
    //    不受时间管理的所有消费
    @ExcelIgnore
    private BigDecimal allConsumption;
    //交款日期
    @ExcelIgnore
    private String paymentDate;
    //发货日期
    @ExcelIgnore
    private String deliveryDate;
    //单位类别
    @ExcelIgnore
    private String cpyType;
    //品种类型
    @ExcelIgnore
    private String pdtType;
    //交款时间
    @ExcelIgnore
    private String paymentTime;
    @ExcelIgnore
    private List<StatisticsVo> statisticsVoList;
    @ExcelIgnore
    //    分项合计
    private BigDecimal subTotal;
}
